<pre>
23. [Roger] SM SVN URL Convention.
base URL: https://scm.starcite.com/svn/mv-g3/

trunk/
       Database/common/  (For current release, Re-runable, Daily build run on common DB:  usCommon)
	           /main/    (For current release, Re-runable, Daily build run on main DB:  usMain000 - usMain004)
			   /archive/    (For Archive)
			   
       language-template/current/Incremental_English_*.csv  (For current release)
	                    /archive/    (For Archive)
branches/SM.15.10.5/
                   Database/common/  (For current release, Re-runable, Daily build run on common DB:  usCommon)
	                       main/    (For current release, Re-runable, Daily build run on main DB:  usMain000 - usMain004)
			               archive/    (For Archive)
			   
                           language-template/current/Incremental_English_*.csv  (For current release)
	                       archive/    (For Archive)

tags/SM.15.2/SM.15.10.5.30/

archive/ 
(In the future, I think, we can add this folder and move all "archive" from Database, Language template.)


22. [Morgan] SM Project techology related:
If you create a new EJB. not only create  classes: Mediator, Local, Home, Localhome, Remote.
But also update JDNINames.java, jboss.xml, ejb-jar.xml. Then lazy build it.

22. [Morgan] SM Project techology related:
If you create a new table in database.
You need to update dbtype.xml. Then let it new full build to update file:
hibernate-service.ear/jboss-services.xml.

21. [Roger] About I18N, we have three levels:
'Account Level
use usMain003
Select * from TSystemEnumeration

'System Level
use usCommon
Select * from tsysresourceelement

(select * from tsysresourceset)

'System Default Level
use usCommon
Select * from tsysresourceelement where sysresourcesetid=2008  ( use English by default)

20. [Yanni]
RFP Summary Report(Download)
VendorId is got from TVendorDetail.vendorId.  It is IMD id, not TVendor.id.

For RFP Summary Report (Online and download)
Vendor Name is got from TRFPInvitee.propName  not  TRFPVendorDetail.propName. 
Normally, in other report, we got vendorName from TRFPVendorDetail.propName.


19.[Reporting Team]
TRFPInvitee   ->Move to->   TRFPVendor   ->Add->   Peer Add on 
Long long ago               2010.4                 2011.8
Doesn't migrate data from TRFPInvitee to TRFPVendor


18. [Reporting Team] Script Result:
use usCommon
select integrationLogid from TRFPIntegrationLog where rfpoid is not null and integrationrfpid = 0
-- ResultA: 0 item return. It means that, there is no dirty data.

use usCommon
select integrationLogid from TRFPIntegrationLog where rfpoid is not null and integrationrfpid in 
(select id from usMain003..TIntegrationRfp where rfpid = 0)
--ResultC: there are around 2200 item return. it mean that, we alows this case existing.


17. [Reporting Team]
Old Tables:  TRFPInvitee (rfpId, vendorId),  TRFP, TVendor, TVendorDetail.
New Tables: TRFPVendor(IntegerationRFPId, vendorId <=> VendorOID), TIntegerationRFP

TRFPInvitee.sendDate <=> TRFPVendor.isSentFlg

About Peer Add on
TRFPVendor.creationType = Competitive Suggestion


16. [SM Team] SM Local DB (Old):
TVendor.vendorId  = TVendorDetail.id
VendorName:  TVendorDetail.propName

TVendorIDOIDMapping.vendorId = TVendor.id

In TVendorIDOIDMapping:  vendorOID (1)<-> (n) vendorId


15. [SM Team] Concept Clarification
GuestRoom == SleepingRoom
FunctionSpace == FunctionRoom == MeetingSpace == EventSpace


14. [SM Team] Concept Clarification
Planner     vs     Supplier(Vendor,Hotel)
    RFP(Requirment)       Response
Info:  startDate            
       endDate 	
	   Sleeping Room
	   Meeting Room

There are three types of date range responses, for example:
Planner request  
01/01 - 01/04    Prefer request.
01/02 - 01/05    Planner alternative request.
Hotel reponse:
01/01 - 01/04    Prefer reponse.
01/02 - 01/05    Planner alternative reponse.
01/03 - 01/06    Hotel alternative reponse.

Vendor Level Response   vs   Data Range Level Response
Vendor Level Response Status   vs   Data Range Level Response Status
If there are several date range status: Accept, Conracted, Decline.
So the vendor level reponse status picks up the best one.
Contracted > Accept > Partial Accept > Decline.

There are two ways to charge fee:   Rental, Food, Beverage, Miscellaneous
By event:   eventR, eventF, eventB, eventM  (There are several events, you need to sum them.)
By quick rate:   quickRateR, quickRateF, quickRateB, quickRateM
Also pay attention to: UnitType,
Currently, SM only supports "Flat"(Total), But New GLC supports "Flat", "PerPerson", "PerDay".

Reponse Datail                    vs                    Report
eventR + eventF + eventB + eventM            quickRateR + eventF + eventB + quickRateM

Two Question:
How to get attendees: get it from RFP Attendees?
For UnitType: PerPerson, It should means  PerPerson for all days, not 1 day?

GLC: Global Leader Center    


13. [SM Team] What's IAD used for?
IAD is created for PM, QA and other developers.
1. PM can review it to make sure the requirement understanding is on the same page.
2. QA can review it to get requirment information and know how to test it in details and knows all impacts.
3. Other developers can review it to be helpful for code review and feature integration.


12. [Morgan] Account Password: (Meeting Room)
starcite\training     p@ssw0rd


11. [Morgan] Bussiness Knowledge
If you delete a user with the login name, e.g. morgan0329@usstep.
Then you create a new one with the same login name. It will failed.
So you can go to Admin site to grant permission to  "undeleteuser" permssion to your account.
Then relogin with an user to undelete previous user.


10. [SM Team] For QA Database information.
account/password:  g3ussqluser/#winning(for US)    or  g3apsqluser/#winning(for AP)
account/password:  sa/#winning (for both US and AP)


9. [SM Team] For all SM QA environments:
account: starcite\sh-mvengineer
password: p@ssword1
When you use this account can not login SM servers, if it failed.
Please Do following thing:
1 Check this server belongs to SM team or not?
2 Check whether it is taked up by others at that time.
3 Ask Morgan.L for help.


8. SQL Command - get Question By meeting name.
use usMain003

select accountid, name, formid, * from Tmeeting where name like 'MeetingName-Morgan62%'

select distinct q.id, q.content, qfe.id, rfe.formid, f.formTypeid from Tquestion as q 
 inner join  TFormElement as qfe on q.id=qfe.questionid 
 inner join TFormElement as rfe on qfe.id = rfe.formElementid and rfe.enabled=1
 inner join TForm f on rfe.formId=f.id
 inner join TType t on f.formTypeId=t.id

 where f.accountId = '30000017' and f.deleted=0 and qfe.deleted=0 and qfe.suppressed=0
and (t.name = 'PROFILE_FORM' or t.name ='PROCESS_FORM') 
and  rfe.formid = '100000021611'

(rfe.enable= 1 means this question is enable in this form.)


7. Company Wifi
Wifi Name: eagle
Password:  whiteboard1650


6. SQL Command - Check LinkedServer
select * from usEBCommon.usCommon.g3ussqluser.tvendordetail


5. SSO UAT
App 10.200.31.93
App 10.200.31.94
https://10.200.31.93:9999/pingfederate/app
Administrator/P@ssw0rd1


SSO Stage
https://usstagecmnapp01.eng.starcite.com:9999/pingfederate/app
Administrator/P@ssw0rd1
https://usstagecmnapp02.eng.starcite.com:9999/pingfederate/app


4. MKV QAInternal:
Host file: 10.136.4.88 supplier.starcite.dev.com
http://supplier.starcite.dev.com/
demoadmin123
p@ssw0rd1   (0 is zero not Oh)

Host file: 10.136.4.88 sales.hiltonmeetings.dev.com
http://sales.hiltonmeetings.dev.com/
demoadmin123
p@ssw0rd1   (0 is zero not Oh)


4. Web Email site: https://scwebmail.starcite.com


3. Proxy Address:
vsjcproxy01.starcite.com 3128


2. Company Meeting
Skype Call: +18778691746


1. Update password of user to "P@ssword1"
update t_user set password = 'KkJM3JkLwYaQFGLowqAKEeYhGUqQYHMg'

--Morgan: please inform CBS to update password for you.
update dbo.[user] set password = 'Udpibkr9E+EszkjxbU0+Pg==' where accountID != 
(select accountid from [account] where accountName='_System')

</pre>